package net.hn.hnms.biz.plan.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import net.hn.hnms.biz.plan.domain.DimShift;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

public interface DimShiftMapper extends BaseMapper<DimShift> {


    @Select("<script>" +
            " select mine_code as mineCode,mine_name as mineName from mine_code_map where type =#{type} order by sort" +
            "</script>")
    List<Map<String, String>> getMonthlySelect(@Param("type") String type);

    @Select("<script>" +
            " select mine_code as mineCode,mine_name as mineName from mine_code_map order by sort" +
            "</script>")
    List<Map<String, String>> getMonthlySelectFoo();
}
